<html>
    <head>
        <script src="//ajax.googleapis.com/ajax/libs/jquery/1.10.2/jquery.min.js"></script> 
        <title> DO  THI QUYEN </title>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<link rel="stylesheet" type="text/css" href="public/css/style.css">
    </head>
    
    <body>
        <?php
        require_once 'model/db.php';
        ?>



<?php 
    $query = "SELECT * FROM companies";
    $companies = getPages($query);
    $query = "SELECT * FROM apps";
    $apps = getPages($query);
    
?>
  <div class="chulon">
 <h1> DO  THI QUYEN</h1></div>
<div class="bang">
<form method="POST">
    Min fans<input type="text" name="min_fans" value="1" id="min_fans" ><br>
    Max fans<input type="text" name="max_fans" value="10"><br>
    Keyword <input type="text" name="keyword" value="cafe"><br>
    Company<select name="id_company">
        <option value="0"> company</option>
        <?php foreach ($companies as $company): ?>
        <option value="<?php echo $company['id'] ?>"><?php echo $company['name']?></option>
        <?php        endforeach;?>
    </select><br>
    
     App :<select name="id_apps">
         <option value="0"> App</option>
        <?php foreach ($apps as $app): ?>
        <option value="<?php echo $app['id'] ?>"><?php echo $app['name']?></option>
        <?php        endforeach;?>
     </select><br>
     
    <input type="submit" name="submit"><br>
    <input type="button" name="check" value="check" id="check">
</form></div>

<?php if (isset($_POST['submit'])):?>
    <?php 
    
        $min_fans = $_POST['min_fans'];//TODO
        $max_fans = $_POST['max_fans'];//TODO
        $keyword = $_POST['keyword'];//TODO
        $company=$_POST["id_company"];
        $apps=$_POST["id_apps"];
        if(!empty($company))
            $company="companies.id=$company AND";
        else
           $company="";
        if(!empty($apps))
            $apps="apps.id='$apps' AND";
        else
           $apps="";
        
       
        
        if(empty($max_fans)&& !empty($min_fans))
        {
          $query="SELECT * FROM pages
            INNER JOIN apps_pages ON pages.id=apps_pages.id_page
            INNER JOIN apps ON apps.id=apps_pages.id_app
            INNER JOIN companies ON companies.id=apps.id_company
            where $company
                  $apps 
                  pages.likes>= $min_fans and
                  pages.description LIKE '% $keyword %'
                  LIMIT 0,10";
        }
        else if(!empty($max_fans)&& empty($min_fans))
        {
          $query="SELECT * FROM pages
            INNER JOIN apps_pages ON pages.id=apps_pages.id_page
            INNER JOIN apps ON apps.id=apps_pages.id_app
            INNER JOIN companies ON companies.id=apps.id_company
            where $company
                  $apps
                  pages.likes<= $max_fans and
                  pages.description LIKE '% $keyword %'
                  LIMIT 0,10";
        }
        else if(empty($max_fans)&& empty($min_fans))
        {
           $query="SELECT * FROM pages
            INNER JOIN apps_pages ON pages.id=apps_pages.id_page
            INNER JOIN apps ON apps.id=apps_pages.id_app
            INNER JOIN companies ON companies.id=apps.id_company
            where $company
                  $apps
                  pages.description LIKE '% $keyword %'
                  LIMIT 0,10";
        }
        else
        {  
        $query="SELECT * FROM pages
            INNER JOIN apps_pages ON pages.id=apps_pages.id_page
            INNER JOIN apps ON apps.id=apps_pages.id_app
            INNER JOIN companies ON companies.id=apps.id_company
            where $company
                  $apps
                  pages.likes>= $min_fans and
                  pages.likes<= $max_fans and
                  pages.description LIKE '% $keyword %'
                  LIMIT 0,10";
        }
        
 
       var_dump($query);
       
        $pages = getPages($query);
      
    ?>

    <?php if (!empty($pages)):?>
    <table border ="1">
        <tr>
             <td> STT </td>
            <td> profile </td>
             <td> likes </td>
              <td> Company </td>
                <td> description </td>
                <td >website </td>
               
            
        </tr>
      
        <?php foreach ($pages as $page):?>
            <tr>
                <td><?php echo $page['pid'] ?></td>
                <td><img src="<?php echo $page['picture']?>"></td>
                <td><?php echo $page['likes'] ?></td>
                <td><?php echo $page['name'] ?></td>
                <td><?php echo substr($page["description"], 0,100) ?></td>
                <td><a href='<?php echo $page["website"] ?>'><?php echo $page['link'] ?></td>
                <?php // var_dump($page);die();?>
            </tr>
        <?php endforeach; ?>
    </table> 

    <?php endif;?>
<?php endif;?>
        
        <script>
            $(document).ready(function(){
                $('#check').click(function(){
                    var min_fans=$('#min_fans').val();
                    var flag = checkNumber(min_fans);
                    if(flag){
                        alert('is number');
                    }else{
                        alert('is not number');
                    }
                });
                function checkNumber(val){
                    if($.isNumeric(val)){
                        return true;
                    }else{
                        return false;
                    }
                }
                    
            });
        </script>
        
    </body>
</html>
